The following iMIS fields are available in the Letter System, and display for each MS Word template in the Report Fields field on the Detail Report Parameters window (select Utilities > Report Specs, select a template, click Edit, and click Parameters):
Note: You can add other fields to your MS Word templates (see Adding a field to a Letter System template).
Customer Management
Name.CO_ID
Name.COMPANY
Name.COUNTY
Name.DESIGNATION
Name.EMAIL
Name.FIRST_NAME
Name.FULL_NAME
Name.ID
Name.INFORMAL
Name.LAST_NAME
Name.MIDDLE_NAME
Name.PREFIX
Name.SUFFIX
Name.TITLE
Name_Address.ADDRESS_1
Name_Address.ADDRESS_2
Name_Address.ADDRESS_3
Name_Address.CITY
Name_Address.COUNTRY
Name_Address.CRRT
Name_Address.FULL_ADDRESS
Name_Address.MAIL_CODE
Name_Address.STATE_PROVINCE
Name_Address.ZIP
Events
Meet_Master.ADDRESS_1
Meet_Master.ADDRESS_2
Meet_Master.ADDRESS_3
Meet_Master.BEGIN_DATE
Meet_Master.CITY
Meet_Master.COORDINATORS
Meet_Master.COUNTRY
Meet_Master.DIRECTIONS
Meet_Master.END_DATE
Meet_Master.NOTES
Meet_Master.STATE_PROVINCE
Meet_Master.TITLE
Meet_Master.ZIP
Order_Meet.ARRIVAL
Order_Meet.DEPARTURE
Order_Meet.MEETING
Orders.BALANCE
Orders.CO_ID
Orders.COMPANY
Orders.CRRT
Orders.EMAIL
Orders.FULL_ADDRESS
Orders.FULL_NAME
Orders.MAIL_CODE
Orders.NOTES
Orders.ORDER_NUMBER
Orders.ST_ID
Orders.TITLE
Orders.TOTAL_CHARGES
Orders.TOTAL_PAYMENTS
Exposition
Meet_Master.ADDRESS_1
Meet_Master.ADDRESS_2
Meet_Master.ADDRESS_3
Meet_Master.BEGIN_DATE
Meet_Master.CITY
Meet_Master.COORDINATORS
Meet_Master.COUNTRY
Meet_Master.DIRECTIONS
Meet_Master.END_DATE
Meet_Master.NOTES
Meet_Master.STATE_PROVINCE
Meet_Master.TITLE
Meet_Master.ZIP
Order_Meet.ARRIVAL
Order_Meet.DEPARTURE
Order_Meet.MEETING
Orders.BALANCE
Orders.CO_ID
Orders.COMPANY
Orders.CRRT
Orders.EMAIL
Orders.FULL_ADDRESS
Orders.FULL_NAME
Orders.MAIL_CODE
Orders.NOTES
Orders.ORDER_NUMBER
Orders.ST_ID
Orders.TITLE
Orders.TOTAL_CHARGES
Orders.TOTAL_PAYMENTS
Fundraising
Fields are created from the view and will display the max and sum prefix.
max(Activity.ACTIVITY_TYPE)
max(Activity.DESCRIPTION)
max(Activity.ORIGINATING_TRANS_NUM)
max(Activity.TAXABLE_VALUE)
max(Activity.TRANSACTION_DATE)
max(Name.CITY)
max(Name.CO_ID)
max(Name.COMPANY)
max(Name.COUNTRY)
max(Name.CRRT)
max(Name.EMAIL)
max(Name.FULL_ADDRESS)
max(Name.FULL_NAME)
max(Name.ID)
max(Name.MAIL_CODE)
max(Name.STATE_PROVINCE)
max(Name.TITLE)
max(Name.ZIP)
max(Name_Salutation.SALUTATION_TEXT)
max(Sender_Codes.SENDER_DESCRIPTION)
max(Trans.MERGE_CODE)
sum(Activity.AMOUNT)
Certification
Cert_Program.ID
Cert_Program.PROGRAM_TYPE
Cert_Program.TITLE
Cert_Register.BOARD_NOTIFIED
Cert_Register.CANCELED_DATE
Cert_Register.COMPLETION_DATE
Cert_Register.DEADLINE
Cert_Register.ENROLLED_DATE
Cert_Register.REGISTRATION _ITEM
Cert_Register.STATUS
Cert_Register.STUDENT_ID
Name.CITY
Name.CO_ID
Name.COMPANY
Name.COUNTRY
Name.EMAIL
Name.FULL_NAME
Name.INFORMAL
Name.STATE_PROVINCE
Name_Address.CRRT
Name_Address.FULL_ADDRESS
Name_Address.MAIL_CODE
Referral: Provider Letter
Name.COMPANY
Name.COMPANY_RECORD
Name.DESIGNATION
Name.EMAIL
Name.FIRST_NAME
Name.FULL_ADDRESS
Name.FULL_NAME
Name.ID
Name.INFORMAL
Name.LAST_NAME
Name.MIDDLE_NAME
Name.PREFIX
Name.SUFFIX
Name.TITLE
Name.WORK_PHONE
Orders.BALANCE
Orders.CO_ID
Orders.COMPANY
Orders.FULL_ADDRESS
Orders.FULL_NAME
Orders.ORDER_NUMBER
Orders.ST_ID
Orders.TITLE
Orders.TOTAL_CHARGES
Orders.TOTAL_PAYMENTS
Ref_Client.ADDRESS_1
Ref_Client.ADDRESS_2
Ref_Client.ADDRESS_3
Ref_Client.CITY
Ref_Client.CLIENT_ID
Ref_Client.COMPANY
Ref_Client.COUNTRY
Ref_Client.DATE_CREATED
Ref_Client.EMAIL
Ref_Client.FIRST_NAME
Ref_Client.LAST_FIRST
Ref_Client.LAST_NAME
Ref_Client.MIDDLE_NAME
Ref_Client.NOTE
Ref_Client.STATE
Ref_Client.ZIP
Ref_Provider.COMPANY
Ref_Provider.LAST_FIRST
Ref_Provider.PHONE
Ref_Provider.PROVIDER_ID
Ref_Provider.REFERRAL_COUNT
Ref_Provider.STATUS
Ref_Provider.ZIP
Referral.NO_SHOW
Referral.REFERRAL_FEE
Referral.REFERRAL_ID
Referral: Client Letter
Name.COMPANY
Name.COMPANY_RECORD
Name.DESIGNATION
Name.EMAIL
Name.FIRST_NAME
Name.FULL_ADDRESS
Name.FULL_NAME
Name.INFORMAL
Name.LAST_NAME
Name.MIDDLE_NAME
Name.PREFIX
Name.SUFFIX
Name.TITLE
Name.WORK_PHONE
Ref_Client.ADDRESS_1
Ref_Client.ADDRESS_2
Ref_Client.ADDRESS_3
Ref_Client.CITY
Ref_Client.CLIENT_ID
Ref_Client.COMPANY
Ref_Client.COUNTRY
Ref_Client.DATE_CREATED
Ref_Client.EMAIL
Ref_Client.FIRST_NAME
Ref_Client.LAST_FIRST
Ref_Client.LAST_NAME
Ref_Client.MIDDLE_NAME
Ref_Client.NOTE
Ref_Client.STATE
Ref_Client.ZIP
Ref_Provider.COMPANY
Ref_Provider.LAST_FIRST
Ref_Provider.PHONE
Ref_Provider.PROVIDER_ID
Ref_Provider.REFERRAL_COUNT
Ref_Provider.STATUS
Ref_Provider.ZIP
Referral.NO_SHOW
Referral.REFERRAL_FEE
Referral.REFERRAL_ID